package com.info33.platform.common.mvc.service;

import java.util.HashMap;
import java.util.List;

import com.baomidou.mybatisplus.core.metadata.IPage;
import com.info33.platform.common.mvc.vo.Result;


public interface SqlHelperService {

	Result<?> selectOne(String sql,Class<?> clazz) throws Exception;

	/*Result<?> selectOne(String sql,Class<?> clazz,Object... params) throws Exception;*/

	Result<?> selectAll(String sql,Class<?> clazz) throws Exception;

	/*Result<?> selectAll(String sql,Class<?> clazz,Object... params) throws Exception;*/

	Result<IPage<?>> selectAll(String sql,Class<?> clazz,Integer pageNumber, Integer pageSize) throws Exception;

	/*Result<IPage<?>> selectAll(String sql,Class<?> clazz,Integer pageNumber, Integer pageSize,Object... params) throws Exception;*/

	Result<HashMap<String, Object>> selectOne(String sql) throws Exception;

	/*Result<HashMap<String, Object>> selectOne(String sql,Object... params) throws Exception;*/

	Result<List<HashMap<String, Object>>> selectAll(String sql) throws Exception;    

	/*Result<List<HashMap<String, Object>>> selectAll(String sql,Object... params) throws Exception;*/

	Result<IPage<?>> selectAll(String sql,Integer pageNumber, Integer pageSize) throws Exception;

	/*Result<IPage<?>> selectAll(String sql,Integer pageNumber, Integer pageSize,Object... params) throws Exception;*/

	Result<?> executeUpdate(String sql);

	Result<?> executeDelete(String sql);
}
